I am confusing with Oracle some objects I do modify with ALTER [OBJECT_NAME] while others with CREATE OR REPLACE [OBJECT]
some examples:
ALTER TABLE but no CREATE OR REPLACE?
ALTER VIEW vs CREATE OR REPLACE VIEW?
Why we can CREATE OR REPLACE VIEW but can't CREATE OR REPLACE SEQUENCE?
what are differences? when to use ALTER or when CREATE OR REPLACE (for instance for view) can't find any good explanation on documentation.